<?php
/**
 *   Joomdiet - components/models/recipecategory.php
 *   Author: Juan Dapena Paz (juan@bittingbits.com)
 *   Copyright (C) 2010 Bitting Bits S.L.
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   You should have received a copy of the GNU General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

defined('_JEXEC') or die('Restricted access');
jimport('joomla.application.component.model');

class JoomdietModelRecipeCategory extends JModel
{
    var $_data;
    var $_query;
    
    function __construct()
    {
        parent::__construct();
    }
    
    function _buildQuery()
    {
        $this->_query = 'SELECT * FROM #__joomdiet_Recipes_Category';
        return $this->_query;
    }
    
    function _buildWhere($parent_category = 0)
    {
        $this->_query .= ' WHERE 1=1';
        if ($parent_category != 0) {
            echo 'groar';
            $this->_query .= ' AND parent_category='.$parent_category;
        }
        
        return $this->_query;
    }
    
    function getData($parent_category = 0)
    {
        $this->_buildQuery();
        $this->_buildWhere($parent_category);
        
        $this->_data = $this->_getList($this->_query);
        return $this->_data;
    }
    
    function getCategory($category)
    {
        $query = $this->_buildQuery();
        $query .= ' WHERE id='.$category;
        $this->_db->setQuery($query);
        return $this->_db->loadObject();
    }
}
?>
